﻿CREATE PROCEDURE [acms].[TemplateHierarchy_GetAllByParentId]
	@ParentId int
AS
	SELECT *
	FROM TemplateHierarchy_View
	Where ParentId = @ParentId
	ORDER BY Sequence
RETURN 0;